	create external table jms_ods.sqs_push_pdd_detail_mapping
(
    `id`                  int string,
    `event_type_code`     string comment '一级类型',
    `sub_event_type_code` string comment '二级类型',
    `abnormal_type_name`  string comment '异常类型名称',
    `description`         string comment '详情描述',
    `create_time`         timestamp    comment '创建时间',
    `create_by_code`      string COMMENT '创建人code',
    `create_by_name`      string COMMENT '创建人名称',
    `update_time`         timestamp  comment '更新时间',
    `update_by_code`      string COMMENT '更新人code',
    `update_by_name`      string COMMENT '更新人名称',
    `is_enable`           tinyint COMMENT '启用/禁用  1:启用 2:禁用',
    `is_delete`           tinyint COMMENT '逻辑删除(0:未删除 1:已删除)',

)
    comment '异常信息推送拼多多详情映射表'
	    partitioned by (dt string comment '时间分区')
	    stored as parquet
    location '/dw/hive/jms_ods.db/external/sqs_push_pdd_detail_mapping'
    tblproperties (
      'parquet.column.index.access'= 'true'
);

